package com.station.search.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.station.search.domain.StationInfo;
import org.apache.ibatis.annotations.Mapper;

/**
 * @author: JT
 * @date: 2021/8/31
 * @Title:
 */
@Mapper
public interface StationInfoMapper extends BaseMapper<StationInfo> {

//    @Insert(value = " INSERT INTO " +
//                    "       STATION_INFO " +
//                    " ( id, station_code, station_name, station_type, station_level, location, altitude, height_above_ground, press_altitude, trademark, model, lon, lon_degrees, lon_minute, lon_second, lat, lat_degrees, lat_minute, lat_second, where_is, area, street_office, station_contact, station_contact_number, check_cycle, repair_date, manager, check_company, check_people, is_deleted ) " +
//                    " VALUES " +
//                    " ( #{id}, #{stationCode}, #{stationName}, #{stationType}, #{stationLevel}, #{location}, #{altitude}, #{heightAboveGround}, #{pressAltitude}, #{trademark}, #{model}, #{lon}, #{lonDegrees}, #{lonMinute}, #{lonSecond}, #{lat}, #{latDegrees}, #{latMinute}, #{latSecond}, ST_GeomFromText('POINT(${lon} ${lat})',4326), #{area}, #{streetOffice}, #{stationContact}, #{stationContactNumber}, #{checkCycle}, #{repairDate}, #{manager}, #{checkCompany}, #{checkPeople}, #{isDeleted} )"
//    )
    void saveStationInfo(StationInfo stationInfo);

}
